﻿<%@ Page Title="" Language="C#" MasterPageFile="~/nest1.master" AutoEventWireup="true" CodeBehind="newcd.aspx.cs" Inherits="WebApplication1.newcd" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
    <asp:Panel ID="Panel1" runat="server"   ForeColor="#E6E154" 
        BorderColor="#006600">
    <br />
    <h3 align="center" 
            style="font-family: 'Times New Roman', Times, serif; font-size: xx-large;"> New CD Available</h3>
    <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            DataSourceID="SqlDataSource1" Height="247px" Width="612px" 
            AllowSorting="True" BackColor="#71470F" HorizontalAlign="Center">
            <Columns>
                <asp:BoundField DataField="cdname" HeaderText="CD Name" 
                    SortExpression="cdname" />
                <asp:BoundField DataField="lang" HeaderText="Language" SortExpression="lang" />
                <asp:BoundField DataField="publish" HeaderText="Publisher" 
                    SortExpression="publish" />
                <asp:BoundField DataField="year" DataFormatString="{0:d}" HeaderText="Year" 
                    SortExpression="year" />
                <asp:BoundField DataField="price" HeaderText="Price" SortExpression="price" />
            </Columns>
            <HeaderStyle BackColor="#03342E" Font-Names="Times New Roman" 
                Font-Size="Medium" />
            <RowStyle Font-Names="Times New Roman" Font-Size="Medium" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            SelectCommand="SELECT * FROM [newcd]"></asp:SqlDataSource>
    <br />
    </asp:Panel>
</asp:Content>
